﻿
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PuntoDeVenta
	DROP CONSTRAINT FK_PuntoDeVenta_Sucursal
GO
DROP TABLE dbo.Sucursal
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Empresa SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.PuntoDeVenta SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

GO

alter table puntodeventa drop column sucursalid